Google Cloud SQL for PostgreSQL database target data types
The Google Cloud SQL for PostgreSQL endpoint for Qlik Replicate supports most Google Cloud SQL for PostgreSQL database data types. The following table shows the Google Cloud SQL for PostgreSQL database target data types that are supported when using Qlik Replicate and the default mapping from Qlik Replicate data types. Unsupported data types are listed below the table.
For information on how to view the data type that is mapped from the source, see the section for the source database you are using. For additional information about Qlik Replicate data types, see Replicate data types.
| Qlik Replicate data types | Google Cloud SQL for PostgreSQL database data types |
|
BOOL |
BOOL |
|
BYTES |
BYTEA |
|
DATE |
DATE |
|
TIME |
TIME |
|
DATETIME |
If scale is => 0 and =< 6, then: TIMESTAMP If scale is => 7 and =< 12, then: VARCHAR (37) |
|
INT1 |
SMALLINT |
|
INT2 |
SMALLINT |
|
INT4 |
INTEGER |
|
INT8 |
BIGINT |
|
NUMERIC |
DECIMAL (P, S) |
|
REAL4 |
FLOAT4 |
|
REAL8 |
FLOAT8 |
|
STRING |
If length is 1 - 21845, then: VARCHAR (Length in Bytes = The STRING value multiplied by three) If length is 21846 - 2147483647, then: VARCHAR (65535) |
|
UINT1 |
SMALLINT |
|
UINT2 |
INTEGER |
|
UINT4 |
BIGINT |
|
UINT8 |
BIGINT |
|
WSTRING |
If length is 1 - 21845, then: VARCHAR (Length in Bytes = The WSTRING value multiplied by three) If length is 21846 - 2147483647, then: VARCHAR (65535) |
|
BLOB |
BYTEA |
|
NCLOB |
TEXT |
|
CLOB |
TEXT |